package com.gzsxy.excel.entity;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import lombok.Data;

import java.util.Date;

/**
 * @Author
 * @Description //TODO Excel模板对象
 * @Date 2022/01/08
 * @Param $
 * @return $
 **/
@Data
@ContentRowHeight(30) // 文本行高度
@HeadRowHeight(20) // 标题高度
@ColumnWidth(30) // 默认列宽度
public class SysUserTo {

    /**
     * 登录账号
     */
    @ExcelProperty(index = 0,value = "登录账号")
    @ColumnWidth(15)
    private String account;

    /**
     * 用户名
     */
    @ExcelProperty(index = 1,value = "用户名")
    @ColumnWidth(15)
    private String username;
    /**
     * 出生日期
     */
    @ExcelProperty(index = 2,value = "出生日期")
    @ColumnWidth(15)
    private Date birthday;

    // 毕业院校
    @ExcelProperty(index = 3,value = "毕业院校")
    @ColumnWidth(20)
    private String school;
    // 学历
    @ExcelProperty(index = 4,value = "学历")
    @ColumnWidth(15)
    private String education;
    // 籍贯
    @ExcelProperty(index = 5,value = "籍贯")
    @ColumnWidth(20)
    private String nativePlace;
    // 毕业时间
    @ExcelProperty(index = 6,value = "毕业时间")
    @ColumnWidth(20)
    private Date graduationTime = new Date();
    // 入职时间
    @ExcelProperty(index = 7,value = "入职时间")
    @ColumnWidth(20)
    private Date entryTime = new Date();
    // 职级
    @ExcelProperty(index = 8,value = "职位")
    @ColumnWidth(10)
    private String rank;
    // 工作岗位
    @ExcelProperty(index = 9,value = "工作岗位")
    @ColumnWidth(15)
    private String job;

    /**
     * 手机号码
     */
    @ExcelProperty(index = 10,value = "手机号码")
    @ColumnWidth(15)
    private String phone;
}
